Farina in Natura - estratégia

Importando os dados e observações iniciais.

	venda	data_hora	cliente	mesa	item	produto	quantidade	valor_unit	desconto	total_item
0	460.0	01/02/2022 08:13	CONSUMIDOR	M 1	119.0	SUCO DE LARANJA 400ML	1.0	14,5	0.0	14,5
1	460.0	01/02/2022 08:13	CONSUMIDOR	M 1	121.0	PAO SOURDOUGH OVOS	1.0	15,5	0.0	15,5
2	461.0	01/02/2022 08:14	CONSUMIDOR	M 2	119.0	SUCO DE LARANJA 400ML	1.0	14,5	0.0	14,5
3	461.0	01/02/2022 08:14	CONSUMIDOR	M 2	121.0	PAO SOURDOUGH OVOS	1.0	15,5	0.0	15,5
4	465.0	01/02/2022 09:01	CONSUMIDOR	M 1	46.0	QUICHE BACON 90G	2.0	19,5	0.0	39

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 25998 entries, 0 to 25997
Data columns (total 10 columns):
 #   Column      Non-Null Count  Dtype  
---  ------      --------------  -----  
 0   venda       25992 non-null  float64
 1   data_hora   25992 non-null  object 
 2   cliente     25992 non-null  object 
 3   mesa        22779 non-null  object 
 4   item        25922 non-null  float64
 5   produto     25992 non-null  object 
 6   quantidade  25992 non-null  float64
 7   valor_unit  25992 non-null  object 
 8   desconto    25992 non-null  float64
 9   total_item  25992 non-null  object 
dtypes: float64(4), object(6)
memory usage: 2.0+ MB

Limpeza e manipulação dos dados.

venda            6
data_hora        6
cliente          6
mesa          3219
item            76
produto          6
quantidade       6
valor_unit       6
desconto         6
total_item       6
dtype: int64

	venda	data_hora	cliente	mesa	produto	quantidade	valor_unit	desconto	total_item
121	520.0	02/02/2022 16:57	CONSUMIDOR	M0	BOMBOLONI NUTELLA 80G	2.0	12	0.0	24
122	520.0	02/02/2022 16:57	CONSUMIDOR	M0	TARTELETE DE MORANGO 120G	1.0	18	0.0	18
123	520.0	02/02/2022 16:57	CONSUMIDOR	M0	CROISSANT MUSSATRELA DE	1.0	25,5	0.0	25,5
894	856.0	11/02/2022 19:19	CONSUMIDOR	M0	CROISSANT BRIE PARMA MEL DE	2.0	25,5	0.0	51
895	856.0	11/02/2022 19:19	CONSUMIDOR	M0	VH SANTA HORTENSIA SAUVIG	1.0	59	0.0	59

	venda	data_hora	cliente	mesa	produto	quantidade	valor_unit	desconto	total_item	horario
0	460	2022-02-01 08:13:00	CONSUMIDOR	M 1	SUCO DE LARANJA 400ML	1	14.5	0.0	14.5	2022-02-01
1	460	2022-02-01 08:13:00	CONSUMIDOR	M 1	PAO SOURDOUGH OVOS	1	15.5	0.0	15.5	2022-02-01
2	461	2022-02-01 08:14:00	CONSUMIDOR	M 2	SUCO DE LARANJA 400ML	1	14.5	0.0	14.5	2022-02-01
3	461	2022-02-01 08:14:00	CONSUMIDOR	M 2	PAO SOURDOUGH OVOS	1	15.5	0.0	15.5	2022-02-01
4	465	2022-02-01 09:01:00	CONSUMIDOR	M 1	QUICHE BACON 90G	2	19.5	0.0	39.0	2022-02-01

<class 'pandas.core.frame.DataFrame'>
Int64Index: 25992 entries, 0 to 25997
Data columns (total 10 columns):
 #   Column      Non-Null Count  Dtype         
---  ------      --------------  -----         
 0   venda       25992 non-null  int64         
 1   data_hora   25992 non-null  datetime64[ns]
 2   cliente     25992 non-null  object        
 3   mesa        25992 non-null  object        
 4   produto     25992 non-null  object        
 5   quantidade  25992 non-null  int64         
 6   valor_unit  25992 non-null  float64       
 7   desconto    25992 non-null  float64       
 8   total_item  25992 non-null  float64       
 9   horario     25992 non-null  object        
dtypes: datetime64[ns](1), float64(3), int64(2), object(4)
memory usage: 2.2+ MB

Creating a column name 'hora_minuto'

Creating the column "data" baseadao em "data_hora"

Extracting only the Date from 'data' column

'pt_BR.utf-8'

	venda	data_hora	cliente	mesa	produto	quantidade	valor_unit	desconto	total_item	horario	hora	minuto	hora_minuto	data	hora_do_dia	dia_da_semana	tipo_de_dia	item_count
0	460	2022-02-01 08:13:00	CONSUMIDOR	M 1	SUCO DE LARANJA 400ML	1	14.5	0.0	14.5	2022-02-01	8	13	08:13:00	2022-02-01	manhã	terça	DDS	1
1	460	2022-02-01 08:13:00	CONSUMIDOR	M 1	PAO SOURDOUGH OVOS	1	15.5	0.0	15.5	2022-02-01	8	13	08:13:00	2022-02-01	manhã	terça	DDS	1
2	461	2022-02-01 08:14:00	CONSUMIDOR	M 2	SUCO DE LARANJA 400ML	1	14.5	0.0	14.5	2022-02-01	8	14	08:14:00	2022-02-01	manhã	terça	DDS	1
3	461	2022-02-01 08:14:00	CONSUMIDOR	M 2	PAO SOURDOUGH OVOS	1	15.5	0.0	15.5	2022-02-01	8	14	08:14:00	2022-02-01	manhã	terça	DDS	1
4	465	2022-02-01 09:01:00	CONSUMIDOR	M 1	QUICHE BACON 90G	2	19.5	0.0	39.0	2022-02-01	9	1	09:01:00	2022-02-01	manhã	terça	DDS	1

Verificando divergência dos dados

Creating a Column diference

total_item          53878.3
total_item_verif    22219.1
diference           31659.2
dtype: float64

Gerando um relatório dos dados divergentes

	venda	data	produto	quantidade	valor_unit	total_item	total_item_verif
7039	3571	2022-04-29	CROISSANT	1	10.0	25.5	10.0
7047	3575	2022-04-29	CROISSANT	1	10.0	28.9	10.0
7054	3582	2022-04-29	CROISSANT	1	10.0	25.5	10.0
7072	3599	2022-04-30	CROISSANT	1	10.0	19.5	10.0
7074	3600	2022-04-30	CROISSANT IFOOD	1	12.0	51.0	12.0

Criando um arquivo HTML dos dados divergentes usando Plotly ("ts2" dataframe)

/home/claudio/results/Dados_divergentes_vendas.html

/home/claudio/farina_in_natura001/CSV

GRÁFICO 01

Exploração dos Dados

CROISSANT                       2393
PASTEL DE NATA 60G              1339
CROISSANT  AMENDOAS 100G         742
FOLHADO MACA 80G                 719
SANDUICHE DE PEPERONI BRIE       596
COOKIES 80G                      559
CROISSANT IFOOD                  534
SOURDOUGH AZEITONA E ALECRIM     517
FOLHADO FRANGO 160G              500
BOMBOLONI DOCE DE LEITE 80G      487
Name: produto, dtype: int64

Converting a Series to a dataframe and changing the namee of the column

	produto	quantidade
0	CROISSANT	2393
1	PASTEL DE NATA 60G	1339
2	CROISSANT AMENDOAS 100G	742
3	FOLHADO MACA 80G	719
4	SANDUICHE DE PEPERONI BRIE	596

Criando um arquivo HTML usando Plotly

GRÁFICO 02

Find the percentage of itens sold

CROISSANT                       0.092067
PASTEL DE NATA 60G              0.051516
CROISSANT  AMENDOAS 100G        0.028547
FOLHADO MACA 80G                0.027662
SANDUICHE DE PEPERONI BRIE      0.022930
COOKIES 80G                     0.021507
CROISSANT IFOOD                 0.020545
SOURDOUGH AZEITONA E ALECRIM    0.019891
FOLHADO FRANGO 160G             0.019237
BOMBOLONI DOCE DE LEITE 80G     0.018737
Name: produto, dtype: float64

Converting to a Dataframe

	produto	proporção
0	CROISSANT	0.092067
1	PASTEL DE NATA 60G	0.051516
2	CROISSANT AMENDOAS 100G	0.028547
3	FOLHADO MACA 80G	0.027662
4	SANDUICHE DE PEPERONI BRIE	0.022930

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 212 entries, 0 to 211
Data columns (total 2 columns):
 #   Column     Non-Null Count  Dtype  
---  ------     --------------  -----  
 0   produto    212 non-null    object 
 1   proporção  212 non-null    float64
dtypes: float64(1), object(1)
memory usage: 3.4+ KB

inserting a column Ranking based on the value of the column proporção

Criando um arquivo html usando Plotly

Gráfico 03

Inserir um gráfico de pizza da tabela acima

GRÁFICO 3A

Algumas métricas importantes

O número de diferentes itens vendido pela loja é: 212

A média de itens por venda é: 2.79 itens

O número médio de itens vendidos por período do dia é: 
hora_do_dia
manhã    3.046419
noite    2.663510
tarde    2.783376
Name: item_count, dtype: float64

Creating a plot with the TOP itens sold per period of the day

GRÁFICO 04

Creating a plot to show the TOP itens sold by month (fevereiro 2022 -outubro 2022)

GRÁFICO 05

Criar a váriavel mes baseada na variavel horario

/tmp/ipykernel_2908/1953160630.py:1: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy

Creating the plot

Creating a table and an animated frequencie line

	horario	item_count
0	2022-02-01	74
1	2022-02-02	88
2	2022-02-03	81
3	2022-02-04	110
4	2022-02-05	112

GRAFICO 06

GRAFICO 07

Grafico 08

Investigando dados atipicos

GRÁFICO 09

	hora	item_count
0	7	8
1	9	5
2	10	5
3	11	7
4	12	4
5	13	8
6	14	5
7	15	3
8	16	2254
9	17	3
10	18	1

GRÁFICO 10

Encontrados dados atípicos nos dias 23 de Junho de 2022 e 30 de Julho de 2022, portanto uma filtragem desses dados se faz necessária

Mais informações relevantes

Vendas dias de semana (DDS) vs Final de semana (FDS)

	horario	item_count
0	2022-02-01	74
1	2022-02-02	88
2	2022-02-03	81
3	2022-02-04	110
4	2022-02-07	61

	horario	item_count
0	2022-02-05	112
1	2022-02-06	121
2	2022-02-12	108
3	2022-02-13	186
4	2022-02-19	107

Vendas dia de semana(DDS)

O menor número de vendas em um dia de semana foi: 
1
O maior número de vendas em um dia de semana foi: 
241
O número médio de vendas em um dia de semana é: 
75.81005586592178

Vendas final de semana (FDS)

O menor número de vendas em um dia de fim-de-semana foi: 
65
O  maior número de vendas em um dia fim-de-semana foi: 
227
O número médio de vendas em um dia fim-de-semana é: 
133.73611111111111

Número de itens médios vendidos por cada pedido

O número médio de itens em cada venda por tipo de dia é: 
tipo_de_dia
DDS    2.650391
FDS    2.836230
Name: item_count, dtype: float64

Itens vendidos por tipo de dia

Grafico 10A

	horario	tipo_de_dia	item_count
0	2022-02-01	DDS	74
1	2022-02-02	DDS	88
2	2022-02-03	DDS	81
3	2022-02-04	DDS	110
4	2022-02-05	FDS	112

Grafico 10B

Faturamento por tipo de dia (DDS x FDS)

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 179 entries, 0 to 178
Data columns (total 2 columns):
 #   Column      Non-Null Count  Dtype  
---  ------      --------------  -----  
 0   horario     179 non-null    object 
 1   total_item  179 non-null    float64
dtypes: float64(1), object(1)
memory usage: 2.9+ KB

Grafico 11

Gráfico 11B

Número de itens vendidos por dia da semana

	horario	item_count
0	2022-02-01	74
1	2022-02-02	88
2	2022-02-03	81
3	2022-02-04	110
4	2022-02-05	112

GAFICO 12

	dia_da_semana	horario	item_count
0	domingo	2022-02-06	121
1	domingo	2022-02-13	186
2	domingo	2022-02-20	156
3	domingo	2022-02-27	86
4	domingo	2022-03-06	126
5	domingo	2022-03-13	145
6	domingo	2022-03-20	140
7	domingo	2022-03-27	121
8	domingo	2022-04-03	93
9	domingo	2022-04-10	77

Grafico 13

Plotly Express (px)

'/home/claudio/results/grafico13 - Vendas_agregadas_itens_dias_semana_PX.html'

Graphic Objects (go)

expr: syntax error: missing argument after ‘8’

Horário de vendas dos itens por dia da semana

/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7358

Modo Simples

Grafico 14

Modo Complexo - Graphic Objects

Distribuição de vendas por hora do dia

GRAFICO 15

How to use Graphics Objects

Distribuição de vendas por dia da semana e hora do dia

Grafico 16

Grafico 16B

Detalhamento do porcentual das vendas pelo periodo do dia

criando uma coluna no dataframe "transactions_filtrada_2"

'/home/claudio/results/grafico016B - percentual_vendas_hora_dia.html'

Grafico 17

Quantidade de itens vendidos por dia da semana e período

/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7505

expr: syntax error: missing argument after ‘8’

	dia_da_semana	hora_do_dia	item_count
0	segunda	manhã	587
1	segunda	noite	1354
2	segunda	tarde	548
3	terça	manhã	545
4	terça	noite	1359
5	terça	tarde	619
6	quarta	manhã	642
7	quarta	noite	1403
8	quarta	tarde	811
9	quinta	manhã	526
10	quinta	noite	1459
11	quinta	tarde	729
12	sexta	manhã	744
13	sexta	noite	1575
14	sexta	tarde	669
15	sábado	manhã	1512
16	sábado	noite	2096
17	sábado	tarde	986
18	domingo	manhã	2310
19	domingo	noite	1793
20	domingo	tarde	932

0      587
3      545
6      642
9      526
12     744
15    1512
18    2310
Name: item_count, dtype: int64

Grafico 18

Vendas por hora

	item_count
hora
6	41
7	524
8	1289
9	1749
10	1817
11	1446
12	737
13	627
14	769
15	1249
16	1912
17	3279
18	2917
19	2416
20	2094
21	333

Apriori Algorithm, Method 1

All day results

Rule: ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA
Support: 0.0061068702290076335
Confidence: 0.5416666666666666
Lift: 70.95833333333333
=====================================
Rule: CROISSANT -> ADICIONAL DE MUSSARELA
Support: 0.009395184967704051
Confidence: 0.8333333333333333
Lift: 4.038607474862455
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.006928948913681738
Confidence: 0.9076923076923077
Lift: 4.398975526465566
=====================================
Rule: AGUA MINERAL S/GAS 500ML -> CROISSANT
Support: 0.01996476805637111
Confidence: 0.4197530864197531
Lift: 2.0342615428936814
=====================================
Rule: PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS AVEIA
Support: 0.007868467410452143
Confidence: 0.24814814814814815
Lift: 9.107678799489145
=====================================
Rule: CROISSANT -> CAFE CATUAI VERMELHO C/LEITE G
Support: 0.007868467410452143
Confidence: 0.43506493506493504
Lift: 2.1084677985645546
=====================================
Rule: CROISSANT -> CAFE CATUAI VERMELHO G 200ML
Support: 0.013740458015267175
Confidence: 0.46799999999999997
Lift: 2.2680819578827545
=====================================
Rule: CROISSANT -> CAFE COLMEIA C/ LEITE G 200ML
Support: 0.00551967116852613
Confidence: 0.5280898876404494
Lift: 2.5592973211487915
=====================================
Rule: CROISSANT -> CAFE COLMEIA G 200ML
Support: 0.007633587786259542
Confidence: 0.4276315789473684
Lift: 2.0724433094688917
=====================================
Rule: CROISSANT -> LARANJA 400 ML
Support: 0.021374045801526718
Confidence: 0.6275862068965518
Lift: 3.041489215551587
=====================================
Rule: SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA MEL DE
Support: 0.005989430416911333
Confidence: 0.2451923076923077
Lift: 5.394864341085272
=====================================
Rule: CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD
Support: 0.005167351732237228
Confidence: 0.4356435643564356
Lift: 9.391151773405188
=====================================
Rule: MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT PAIN DE CHOC
Support: 0.00540223135642983
Confidence: 0.2358974358974359
Lift: 5.046901172529314
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.005637110980622431
Confidence: 0.5
Lift: 72.16101694915254
=====================================

Convert a list to a Dataframe

	Rule	Support	Confidence	Lift
0	ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA	0.0061068702290076335	0.5416666666666666	70.95833333333333
1	CROISSANT -> ADICIONAL DE MUSSARELA	0.009395184967704051	0.8333333333333333	4.038607474862455
2	CROISSANT -> ADICIONAL DE PRESUNTO	0.006928948913681738	0.9076923076923077	4.398975526465566
3	AGUA MINERAL S/GAS 500ML -> CROISSANT	0.01996476805637111	0.4197530864197531	2.0342615428936814
4	PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS A...	0.007868467410452143	0.24814814814814815	9.107678799489145
5	CROISSANT -> CAFE CATUAI VERMELHO C/LEITE G	0.007868467410452143	0.43506493506493504	2.1084677985645546
6	CROISSANT -> CAFE CATUAI VERMELHO G 200ML	0.013740458015267175	0.46799999999999997	2.2680819578827545
7	CROISSANT -> CAFE COLMEIA C/ LEITE G 200ML	0.00551967116852613	0.5280898876404494	2.5592973211487915
8	CROISSANT -> CAFE COLMEIA G 200ML	0.007633587786259542	0.4276315789473684	2.0724433094688917
9	CROISSANT -> LARANJA 400 ML	0.021374045801526718	0.6275862068965518	3.041489215551587
10	SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA ...	0.005989430416911333	0.2451923076923077	5.394864341085272
11	CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD	0.005167351732237228	0.4356435643564356	9.391151773405188
12	MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT P...	0.00540223135642983	0.2358974358974359	5.046901172529314
13	CROISSANT -> ADICIONAL DE PRESUNTO	0.005637110980622431	0.5	72.16101694915254

Grafico 19

'/home/claudio/results/grafico19 - Aplicando_Apriori_Modelo_01.html'

Resultados - Manhã

expr: syntax error: missing argument after ‘8’

/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7649

Resultado da função "associantion_results_manha" período Manhã

Rule: ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA
Support: 0.009764758100310697
Confidence: 0.5945945945945946
Lift: 40.5945945945946
=====================================
Rule: AGUA MINERAL S/GAS 500ML -> ADICIONAL DE MUSSARELA
Support: 0.005326231691078562
Confidence: 0.3243243243243244
Lift: 5.294947121034079
=====================================
Rule: CROISSANT -> ADICIONAL DE MUSSARELA
Support: 0.015090989791389259
Confidence: 0.918918918918919
Lift: 3.344627341396324
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.013315579227696404
Confidence: 0.9090909090909091
Lift: 3.3088559259803203
=====================================
Rule: CROISSANT BRIE PARMA MEL DE -> AGUA MINERAL SEM GAS 500 ML
Support: 0.007545494895694629
Confidence: 0.2
Lift: 5.006666666666667
=====================================
Rule: PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS AVEIA
Support: 0.024411895250776743
Confidence: 0.2972972972972973
Lift: 3.9170222854433385
=====================================
Rule: BOWL DE IOGURTE FRUTAS AVEIA -> SELECAO DE PAES GELEIA
Support: 0.010208610741233911
Confidence: 0.2674418604651163
Lift: 3.2570081709616594
=====================================
Rule: LARANJA 400 ML -> CAFE CATUAI VERMELHO C/LEITE G
Support: 0.007989347536617843
Confidence: 0.23684210526315788
Lift: 3.629967776584318
=====================================
Rule: COOKIES 80G IFOOD -> CROISSANT IFOOD
Support: 0.005770084332001775
Confidence: 0.619047619047619
Lift: 7.621389539422324
=====================================
Rule: CROISSANT OVOS BACON MEL -> CROISSANT BRIE PARMA MEL DE
Support: 0.007989347536617843
Confidence: 0.2
Lift: 4.506
=====================================
Rule: SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA MEL DE
Support: 0.00887705281846427
Confidence: 0.22222222222222224
Lift: 6.032128514056224
=====================================
Rule: CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD
Support: 0.008433200177541057
Confidence: 0.5428571428571428
Lift: 6.683372365339578
=====================================
Rule: SOURDOUGH 369G IFOOD -> CROISSANT IFOOD
Support: 0.008433200177541057
Confidence: 0.59375
Lift: 7.309938524590163
=====================================
Rule: SUCO DE LARANJA 400ML -> CROISSANT MUSSATRELA DE
Support: 0.006657789613848202
Confidence: 0.2459016393442623
Lift: 6.674896306537625
=====================================
Rule: CROISSANT OVOS BACON MEL -> SUCO DE LARANJA 400ML
Support: 0.008433200177541057
Confidence: 0.2289156626506024
Lift: 5.157469879518072
=====================================
Rule: MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT PAIN DE CHOC
Support: 0.007101642254771416
Confidence: 0.2857142857142857
Lift: 5.646616541353383
=====================================
Rule: CROISSANT -> ADICIONAL DE PRESUNTO
Support: 0.009320905459387484
Confidence: 0.5675675675675677
Lift: 42.624324324324334
=====================================
Rule: AGUA MINERAL S/GAS 500ML -> CROISSANT
Support: 0.006657789613848202
Confidence: 0.2054794520547945
Lift: 3.354675402025015
=====================================
Rule: CROISSANT -> BOWL DE IOGURTE FRUTAS AVEIA
Support: 0.006213936972924989
Confidence: 0.29166666666666663
Lift: 4.470238095238095
=====================================
Rule: CROISSANT -> LARANJA 400 ML
Support: 0.006657789613848202
Confidence: 0.2054794520547945
Lift: 3.149287112105116
=====================================
Rule: PAO SOURDOUGH OVOS -> CROISSANT
Support: 0.005326231691078562
Confidence: 0.3076923076923077
Lift: 5.590570719602978
=====================================
Rule: PAO SOURDOUGH OVOS -> CROISSANT
Support: 0.005326231691078562
Confidence: 0.3076923076923077
Lift: 4.71585557299843
=====================================
Rule: CROISSANT -> SANDUICHE DE PEPERONI BRIE
Support: 0.006213936972924989
Confidence: 0.3783783783783784
Lift: 3.1928332827209234
=====================================

Converting the list to dataframe - Manhã

	Rule	Support	Confidence	Lift
5	PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS A...	0.024411895250776743	0.2972972972972973	3.9170222854433385
2	CROISSANT -> ADICIONAL DE MUSSARELA	0.015090989791389259	0.918918918918919	3.344627341396324
3	CROISSANT -> ADICIONAL DE PRESUNTO	0.013315579227696404	0.9090909090909091	3.3088559259803203
6	BOWL DE IOGURTE FRUTAS AVEIA -> SELECAO DE PAE...	0.010208610741233911	0.2674418604651163	3.2570081709616594
0	ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA	0.009764758100310697	0.5945945945945946	40.5945945945946
16	CROISSANT -> ADICIONAL DE PRESUNTO	0.009320905459387484	0.5675675675675677	42.624324324324334
10	SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA ...	0.00887705281846427	0.22222222222222224	6.032128514056224
14	CROISSANT OVOS BACON MEL -> SUCO DE LARANJA 400ML	0.008433200177541057	0.2289156626506024	5.157469879518072
12	SOURDOUGH 369G IFOOD -> CROISSANT IFOOD	0.008433200177541057	0.59375	7.309938524590163
11	CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD	0.008433200177541057	0.5428571428571428	6.683372365339578
9	CROISSANT OVOS BACON MEL -> CROISSANT BRIE PAR...	0.007989347536617843	0.2	4.506
7	LARANJA 400 ML -> CAFE CATUAI VERMELHO C/LEITE G	0.007989347536617843	0.23684210526315788	3.629967776584318
4	CROISSANT BRIE PARMA MEL DE -> AGUA MINERAL SE...	0.007545494895694629	0.2	5.006666666666667
15	MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT P...	0.007101642254771416	0.2857142857142857	5.646616541353383
13	SUCO DE LARANJA 400ML -> CROISSANT MUSSATRELA DE	0.006657789613848202	0.2459016393442623	6.674896306537625
17	AGUA MINERAL S/GAS 500ML -> CROISSANT	0.006657789613848202	0.2054794520547945	3.354675402025015
19	CROISSANT -> LARANJA 400 ML	0.006657789613848202	0.2054794520547945	3.149287112105116
18	CROISSANT -> BOWL DE IOGURTE FRUTAS AVEIA	0.006213936972924989	0.29166666666666663	4.470238095238095
22	CROISSANT -> SANDUICHE DE PEPERONI BRIE	0.006213936972924989	0.3783783783783784	3.1928332827209234
8	COOKIES 80G IFOOD -> CROISSANT IFOOD	0.005770084332001775	0.619047619047619	7.621389539422324
1	AGUA MINERAL S/GAS 500ML -> ADICIONAL DE MUSSA...	0.005326231691078562	0.3243243243243244	5.294947121034079
20	PAO SOURDOUGH OVOS -> CROISSANT	0.005326231691078562	0.3076923076923077	5.590570719602978
21	PAO SOURDOUGH OVOS -> CROISSANT	0.005326231691078562	0.3076923076923077	4.71585557299843

Apriori Algorithm, Method 2

Transformando o rsultado da função "apriori_results_method_2" em um DATAFRAME

Fazendo a limpeza do DATAFRAME

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 60 entries, 0 to 59
Data columns (total 9 columns):
 #   Column              Non-Null Count  Dtype  
---  ------              --------------  -----  
 0   antecedents         60 non-null     string 
 1   consequents         60 non-null     string 
 2   antecedent support  60 non-null     float64
 3   consequent support  60 non-null     float64
 4   support             60 non-null     float64
 5   confidence          60 non-null     float64
 6   lift                60 non-null     float64
 7   leverage            60 non-null     float64
 8   conviction          60 non-null     float64
dtypes: float64(7), string(2)
memory usage: 4.3 KB

	antecedents	consequents	antecedent support	consequent support	support	confidence	lift	leverage	conviction
0	CROISSANT, ADICIONAL DE MUSSARELA	ADICIONAL DE PRESUNTO	0.009395	0.007634	0.005637	0.600000	78.600000	0.005565	2.480916
1	CROISSANT, ADICIONAL DE PRESUNTO	ADICIONAL DE MUSSARELA	0.006929	0.011274	0.005637	0.813559	72.161017	0.005559	5.303166
2	ADICIONAL DE PRESUNTO	ADICIONAL DE MUSSARELA	0.007634	0.011274	0.006107	0.800000	70.958333	0.006021	4.943629
3	CROISSANT IFOOD	PASTEL DE NATA 60G IFOOD	0.046389	0.011861	0.005167	0.111392	9.391152	0.004617	1.112008
4	PAO SOURDOUGH OVOS	BOWL DE IOGURTE FRUTAS AVEIA	0.027246	0.031709	0.007868	0.288793	9.107679	0.007005	1.361476

Grafico 20

'/home/claudio/results/grafico20 - Apriori_Method_02_all_Day.html'

/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001
/usr/share/atom/atom: bad option: --pid=7796

expr: syntax error: missing argument after ‘8’

antecedents
(CROISSANT, ADICIONAL DE MUSSARELA)             132.319444
(CROISSANT, ADICIONAL DE PRESUNTO)              123.727273
(ADICIONAL DE PRESUNTO)                         123.727273
(CROISSANT)                                      29.852497
(BOMBOLONI DOCE DE LEITE 80G)                    13.857519
(CROISSANT IFOOD)                                13.610000
(BOMBOLONI NUTELLA 80G, PASTEL DE NATA 60G)      11.864259
(FOLHADO FRANGO 160G, PASTEL DE NATA 60G)        10.807043
(FOLHADO FRANGO 160G)                            10.014217
(CROISSANT  TRADICIONAL 80 G)                     9.120090
(MINI CROISSANT 25G KIT C 5)                      7.845827
(CAFE INTENSO CAPSULA P 50ML)                     7.815052
(BOMBOLONI NUTELLA 80G)                           6.464520
(CROISSANT  AMENDOAS 100G)                        5.951058
(SOURDOUGH 369G)                                  5.620532
(FOCACCIA FORMAGGIO 246G)                         5.281658
(AGUA MINERAL S/GAS 500ML)                        4.844972
(FOLHADO FRANGO 160G, BOMBOLONI NUTELLA 80G)      4.472770
(TORRADA FARINA 165G)                             4.391127
(QUICHE DE TOMATE SECO SALADA)                    4.124911
(CAFE EQUILIBRADO CAPSULA P)                      3.764748
(FOLHADO MACA 80G)                                3.569901
(SANDUICHE DE PEPERONI BRIE)                      3.489744
(CROISSANT, PASTEL DE NATA 60G)                   3.434391
(PASTEL DE NATA 60G)                              2.713261
(CAFE EQUILIBRADO CAPSULA G)                      2.396127
(FOLHADO FRANGO 160G, CROISSANT)                  2.354089
(CROISANT DE CROISSANT QUEIJO)                    2.236385
(PIZZA AL TAGLIO GORGONZOLA E)                    2.223856
(MINI CROISSANT 25G)                              1.825620
(SOURDOUGH SEMI INTEGRAL 370G)                    1.779085
(QUICHE DE BACON SALADA VERDE)                    1.442829
(QUICHE DE FRANGO ALHO PORO)                      1.378164
(MINI CROISSANT PAIN DE CHOC)                     1.369215
(MINI PAIN AU CHOCOLAT 35G)                       1.277934
(SOURDOUGH AZEITONA E ALECRIM)                    1.250919
Name: lift, dtype: float64